package com.base.po.voip;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class HjkcomdataExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public HjkcomdataExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdnumIsNull() {
            addCriterion("idNum is null");
            return (Criteria) this;
        }

        public Criteria andIdnumIsNotNull() {
            addCriterion("idNum is not null");
            return (Criteria) this;
        }

        public Criteria andIdnumEqualTo(Integer value) {
            addCriterion("idNum =", value, "idnum");
            return (Criteria) this;
        }

        public Criteria andIdnumNotEqualTo(Integer value) {
            addCriterion("idNum <>", value, "idnum");
            return (Criteria) this;
        }

        public Criteria andIdnumGreaterThan(Integer value) {
            addCriterion("idNum >", value, "idnum");
            return (Criteria) this;
        }

        public Criteria andIdnumGreaterThanOrEqualTo(Integer value) {
            addCriterion("idNum >=", value, "idnum");
            return (Criteria) this;
        }

        public Criteria andIdnumLessThan(Integer value) {
            addCriterion("idNum <", value, "idnum");
            return (Criteria) this;
        }

        public Criteria andIdnumLessThanOrEqualTo(Integer value) {
            addCriterion("idNum <=", value, "idnum");
            return (Criteria) this;
        }

        public Criteria andIdnumIn(List<Integer> values) {
            addCriterion("idNum in", values, "idnum");
            return (Criteria) this;
        }

        public Criteria andIdnumNotIn(List<Integer> values) {
            addCriterion("idNum not in", values, "idnum");
            return (Criteria) this;
        }

        public Criteria andIdnumBetween(Integer value1, Integer value2) {
            addCriterion("idNum between", value1, value2, "idnum");
            return (Criteria) this;
        }

        public Criteria andIdnumNotBetween(Integer value1, Integer value2) {
            addCriterion("idNum not between", value1, value2, "idnum");
            return (Criteria) this;
        }

        public Criteria andSIdIsNull() {
            addCriterion("s_id is null");
            return (Criteria) this;
        }

        public Criteria andSIdIsNotNull() {
            addCriterion("s_id is not null");
            return (Criteria) this;
        }

        public Criteria andSIdEqualTo(Long value) {
            addCriterion("s_id =", value, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdNotEqualTo(Long value) {
            addCriterion("s_id <>", value, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdGreaterThan(Long value) {
            addCriterion("s_id >", value, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdGreaterThanOrEqualTo(Long value) {
            addCriterion("s_id >=", value, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdLessThan(Long value) {
            addCriterion("s_id <", value, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdLessThanOrEqualTo(Long value) {
            addCriterion("s_id <=", value, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdIn(List<Long> values) {
            addCriterion("s_id in", values, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdNotIn(List<Long> values) {
            addCriterion("s_id not in", values, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdBetween(Long value1, Long value2) {
            addCriterion("s_id between", value1, value2, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdNotBetween(Long value1, Long value2) {
            addCriterion("s_id not between", value1, value2, "sId");
            return (Criteria) this;
        }

        public Criteria andSkuidIsNull() {
            addCriterion("skuId is null");
            return (Criteria) this;
        }

        public Criteria andSkuidIsNotNull() {
            addCriterion("skuId is not null");
            return (Criteria) this;
        }

        public Criteria andSkuidEqualTo(String value) {
            addCriterion("skuId =", value, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkuidNotEqualTo(String value) {
            addCriterion("skuId <>", value, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkuidGreaterThan(String value) {
            addCriterion("skuId >", value, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkuidGreaterThanOrEqualTo(String value) {
            addCriterion("skuId >=", value, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkuidLessThan(String value) {
            addCriterion("skuId <", value, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkuidLessThanOrEqualTo(String value) {
            addCriterion("skuId <=", value, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkuidLike(String value) {
            addCriterion("skuId like", value, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkuidNotLike(String value) {
            addCriterion("skuId not like", value, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkuidIn(List<String> values) {
            addCriterion("skuId in", values, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkuidNotIn(List<String> values) {
            addCriterion("skuId not in", values, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkuidBetween(String value1, String value2) {
            addCriterion("skuId between", value1, value2, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkuidNotBetween(String value1, String value2) {
            addCriterion("skuId not between", value1, value2, "skuid");
            return (Criteria) this;
        }

        public Criteria andSkunameIsNull() {
            addCriterion("skuName is null");
            return (Criteria) this;
        }

        public Criteria andSkunameIsNotNull() {
            addCriterion("skuName is not null");
            return (Criteria) this;
        }

        public Criteria andSkunameEqualTo(String value) {
            addCriterion("skuName =", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameNotEqualTo(String value) {
            addCriterion("skuName <>", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameGreaterThan(String value) {
            addCriterion("skuName >", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameGreaterThanOrEqualTo(String value) {
            addCriterion("skuName >=", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameLessThan(String value) {
            addCriterion("skuName <", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameLessThanOrEqualTo(String value) {
            addCriterion("skuName <=", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameLike(String value) {
            addCriterion("skuName like", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameNotLike(String value) {
            addCriterion("skuName not like", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameIn(List<String> values) {
            addCriterion("skuName in", values, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameNotIn(List<String> values) {
            addCriterion("skuName not in", values, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameBetween(String value1, String value2) {
            addCriterion("skuName between", value1, value2, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameNotBetween(String value1, String value2) {
            addCriterion("skuName not between", value1, value2, "skuname");
            return (Criteria) this;
        }

        public Criteria andMateriaurlIsNull() {
            addCriterion("materiaUrl is null");
            return (Criteria) this;
        }

        public Criteria andMateriaurlIsNotNull() {
            addCriterion("materiaUrl is not null");
            return (Criteria) this;
        }

        public Criteria andMateriaurlEqualTo(String value) {
            addCriterion("materiaUrl =", value, "materiaurl");
            return (Criteria) this;
        }

        public Criteria andMateriaurlNotEqualTo(String value) {
            addCriterion("materiaUrl <>", value, "materiaurl");
            return (Criteria) this;
        }

        public Criteria andMateriaurlGreaterThan(String value) {
            addCriterion("materiaUrl >", value, "materiaurl");
            return (Criteria) this;
        }

        public Criteria andMateriaurlGreaterThanOrEqualTo(String value) {
            addCriterion("materiaUrl >=", value, "materiaurl");
            return (Criteria) this;
        }

        public Criteria andMateriaurlLessThan(String value) {
            addCriterion("materiaUrl <", value, "materiaurl");
            return (Criteria) this;
        }

        public Criteria andMateriaurlLessThanOrEqualTo(String value) {
            addCriterion("materiaUrl <=", value, "materiaurl");
            return (Criteria) this;
        }

        public Criteria andMateriaurlLike(String value) {
            addCriterion("materiaUrl like", value, "materiaurl");
            return (Criteria) this;
        }

        public Criteria andMateriaurlNotLike(String value) {
            addCriterion("materiaUrl not like", value, "materiaurl");
            return (Criteria) this;
        }

        public Criteria andMateriaurlIn(List<String> values) {
            addCriterion("materiaUrl in", values, "materiaurl");
            return (Criteria) this;
        }

        public Criteria andMateriaurlNotIn(List<String> values) {
            addCriterion("materiaUrl not in", values, "materiaurl");
            return (Criteria) this;
        }

        public Criteria andMateriaurlBetween(String value1, String value2) {
            addCriterion("materiaUrl between", value1, value2, "materiaurl");
            return (Criteria) this;
        }

        public Criteria andMateriaurlNotBetween(String value1, String value2) {
            addCriterion("materiaUrl not between", value1, value2, "materiaurl");
            return (Criteria) this;
        }

        public Criteria andPicurlIsNull() {
            addCriterion("picUrl is null");
            return (Criteria) this;
        }

        public Criteria andPicurlIsNotNull() {
            addCriterion("picUrl is not null");
            return (Criteria) this;
        }

        public Criteria andPicurlEqualTo(String value) {
            addCriterion("picUrl =", value, "picurl");
            return (Criteria) this;
        }

        public Criteria andPicurlNotEqualTo(String value) {
            addCriterion("picUrl <>", value, "picurl");
            return (Criteria) this;
        }

        public Criteria andPicurlGreaterThan(String value) {
            addCriterion("picUrl >", value, "picurl");
            return (Criteria) this;
        }

        public Criteria andPicurlGreaterThanOrEqualTo(String value) {
            addCriterion("picUrl >=", value, "picurl");
            return (Criteria) this;
        }

        public Criteria andPicurlLessThan(String value) {
            addCriterion("picUrl <", value, "picurl");
            return (Criteria) this;
        }

        public Criteria andPicurlLessThanOrEqualTo(String value) {
            addCriterion("picUrl <=", value, "picurl");
            return (Criteria) this;
        }

        public Criteria andPicurlLike(String value) {
            addCriterion("picUrl like", value, "picurl");
            return (Criteria) this;
        }

        public Criteria andPicurlNotLike(String value) {
            addCriterion("picUrl not like", value, "picurl");
            return (Criteria) this;
        }

        public Criteria andPicurlIn(List<String> values) {
            addCriterion("picUrl in", values, "picurl");
            return (Criteria) this;
        }

        public Criteria andPicurlNotIn(List<String> values) {
            addCriterion("picUrl not in", values, "picurl");
            return (Criteria) this;
        }

        public Criteria andPicurlBetween(String value1, String value2) {
            addCriterion("picUrl between", value1, value2, "picurl");
            return (Criteria) this;
        }

        public Criteria andPicurlNotBetween(String value1, String value2) {
            addCriterion("picUrl not between", value1, value2, "picurl");
            return (Criteria) this;
        }

        public Criteria andWlpriceIsNull() {
            addCriterion("wlPrice is null");
            return (Criteria) this;
        }

        public Criteria andWlpriceIsNotNull() {
            addCriterion("wlPrice is not null");
            return (Criteria) this;
        }

        public Criteria andWlpriceEqualTo(String value) {
            addCriterion("wlPrice =", value, "wlprice");
            return (Criteria) this;
        }

        public Criteria andWlpriceNotEqualTo(String value) {
            addCriterion("wlPrice <>", value, "wlprice");
            return (Criteria) this;
        }

        public Criteria andWlpriceGreaterThan(String value) {
            addCriterion("wlPrice >", value, "wlprice");
            return (Criteria) this;
        }

        public Criteria andWlpriceGreaterThanOrEqualTo(String value) {
            addCriterion("wlPrice >=", value, "wlprice");
            return (Criteria) this;
        }

        public Criteria andWlpriceLessThan(String value) {
            addCriterion("wlPrice <", value, "wlprice");
            return (Criteria) this;
        }

        public Criteria andWlpriceLessThanOrEqualTo(String value) {
            addCriterion("wlPrice <=", value, "wlprice");
            return (Criteria) this;
        }

        public Criteria andWlpriceLike(String value) {
            addCriterion("wlPrice like", value, "wlprice");
            return (Criteria) this;
        }

        public Criteria andWlpriceNotLike(String value) {
            addCriterion("wlPrice not like", value, "wlprice");
            return (Criteria) this;
        }

        public Criteria andWlpriceIn(List<String> values) {
            addCriterion("wlPrice in", values, "wlprice");
            return (Criteria) this;
        }

        public Criteria andWlpriceNotIn(List<String> values) {
            addCriterion("wlPrice not in", values, "wlprice");
            return (Criteria) this;
        }

        public Criteria andWlpriceBetween(String value1, String value2) {
            addCriterion("wlPrice between", value1, value2, "wlprice");
            return (Criteria) this;
        }

        public Criteria andWlpriceNotBetween(String value1, String value2) {
            addCriterion("wlPrice not between", value1, value2, "wlprice");
            return (Criteria) this;
        }

        public Criteria andWlpriceAfterIsNull() {
            addCriterion("wlPrice_after is null");
            return (Criteria) this;
        }

        public Criteria andWlpriceAfterIsNotNull() {
            addCriterion("wlPrice_after is not null");
            return (Criteria) this;
        }

        public Criteria andWlpriceAfterEqualTo(String value) {
            addCriterion("wlPrice_after =", value, "wlpriceAfter");
            return (Criteria) this;
        }

        public Criteria andWlpriceAfterNotEqualTo(String value) {
            addCriterion("wlPrice_after <>", value, "wlpriceAfter");
            return (Criteria) this;
        }

        public Criteria andWlpriceAfterGreaterThan(String value) {
            addCriterion("wlPrice_after >", value, "wlpriceAfter");
            return (Criteria) this;
        }

        public Criteria andWlpriceAfterGreaterThanOrEqualTo(String value) {
            addCriterion("wlPrice_after >=", value, "wlpriceAfter");
            return (Criteria) this;
        }

        public Criteria andWlpriceAfterLessThan(String value) {
            addCriterion("wlPrice_after <", value, "wlpriceAfter");
            return (Criteria) this;
        }

        public Criteria andWlpriceAfterLessThanOrEqualTo(String value) {
            addCriterion("wlPrice_after <=", value, "wlpriceAfter");
            return (Criteria) this;
        }

        public Criteria andWlpriceAfterLike(String value) {
            addCriterion("wlPrice_after like", value, "wlpriceAfter");
            return (Criteria) this;
        }

        public Criteria andWlpriceAfterNotLike(String value) {
            addCriterion("wlPrice_after not like", value, "wlpriceAfter");
            return (Criteria) this;
        }

        public Criteria andWlpriceAfterIn(List<String> values) {
            addCriterion("wlPrice_after in", values, "wlpriceAfter");
            return (Criteria) this;
        }

        public Criteria andWlpriceAfterNotIn(List<String> values) {
            addCriterion("wlPrice_after not in", values, "wlpriceAfter");
            return (Criteria) this;
        }

        public Criteria andWlpriceAfterBetween(String value1, String value2) {
            addCriterion("wlPrice_after between", value1, value2, "wlpriceAfter");
            return (Criteria) this;
        }

        public Criteria andWlpriceAfterNotBetween(String value1, String value2) {
            addCriterion("wlPrice_after not between", value1, value2, "wlpriceAfter");
            return (Criteria) this;
        }

        public Criteria andWlcommissionshareIsNull() {
            addCriterion("wlCommissionShare is null");
            return (Criteria) this;
        }

        public Criteria andWlcommissionshareIsNotNull() {
            addCriterion("wlCommissionShare is not null");
            return (Criteria) this;
        }

        public Criteria andWlcommissionshareEqualTo(String value) {
            addCriterion("wlCommissionShare =", value, "wlcommissionshare");
            return (Criteria) this;
        }

        public Criteria andWlcommissionshareNotEqualTo(String value) {
            addCriterion("wlCommissionShare <>", value, "wlcommissionshare");
            return (Criteria) this;
        }

        public Criteria andWlcommissionshareGreaterThan(String value) {
            addCriterion("wlCommissionShare >", value, "wlcommissionshare");
            return (Criteria) this;
        }

        public Criteria andWlcommissionshareGreaterThanOrEqualTo(String value) {
            addCriterion("wlCommissionShare >=", value, "wlcommissionshare");
            return (Criteria) this;
        }

        public Criteria andWlcommissionshareLessThan(String value) {
            addCriterion("wlCommissionShare <", value, "wlcommissionshare");
            return (Criteria) this;
        }

        public Criteria andWlcommissionshareLessThanOrEqualTo(String value) {
            addCriterion("wlCommissionShare <=", value, "wlcommissionshare");
            return (Criteria) this;
        }

        public Criteria andWlcommissionshareLike(String value) {
            addCriterion("wlCommissionShare like", value, "wlcommissionshare");
            return (Criteria) this;
        }

        public Criteria andWlcommissionshareNotLike(String value) {
            addCriterion("wlCommissionShare not like", value, "wlcommissionshare");
            return (Criteria) this;
        }

        public Criteria andWlcommissionshareIn(List<String> values) {
            addCriterion("wlCommissionShare in", values, "wlcommissionshare");
            return (Criteria) this;
        }

        public Criteria andWlcommissionshareNotIn(List<String> values) {
            addCriterion("wlCommissionShare not in", values, "wlcommissionshare");
            return (Criteria) this;
        }

        public Criteria andWlcommissionshareBetween(String value1, String value2) {
            addCriterion("wlCommissionShare between", value1, value2, "wlcommissionshare");
            return (Criteria) this;
        }

        public Criteria andWlcommissionshareNotBetween(String value1, String value2) {
            addCriterion("wlCommissionShare not between", value1, value2, "wlcommissionshare");
            return (Criteria) this;
        }

        public Criteria andCouponlistIsNull() {
            addCriterion("couponList is null");
            return (Criteria) this;
        }

        public Criteria andCouponlistIsNotNull() {
            addCriterion("couponList is not null");
            return (Criteria) this;
        }

        public Criteria andCouponlistEqualTo(String value) {
            addCriterion("couponList =", value, "couponlist");
            return (Criteria) this;
        }

        public Criteria andCouponlistNotEqualTo(String value) {
            addCriterion("couponList <>", value, "couponlist");
            return (Criteria) this;
        }

        public Criteria andCouponlistGreaterThan(String value) {
            addCriterion("couponList >", value, "couponlist");
            return (Criteria) this;
        }

        public Criteria andCouponlistGreaterThanOrEqualTo(String value) {
            addCriterion("couponList >=", value, "couponlist");
            return (Criteria) this;
        }

        public Criteria andCouponlistLessThan(String value) {
            addCriterion("couponList <", value, "couponlist");
            return (Criteria) this;
        }

        public Criteria andCouponlistLessThanOrEqualTo(String value) {
            addCriterion("couponList <=", value, "couponlist");
            return (Criteria) this;
        }

        public Criteria andCouponlistLike(String value) {
            addCriterion("couponList like", value, "couponlist");
            return (Criteria) this;
        }

        public Criteria andCouponlistNotLike(String value) {
            addCriterion("couponList not like", value, "couponlist");
            return (Criteria) this;
        }

        public Criteria andCouponlistIn(List<String> values) {
            addCriterion("couponList in", values, "couponlist");
            return (Criteria) this;
        }

        public Criteria andCouponlistNotIn(List<String> values) {
            addCriterion("couponList not in", values, "couponlist");
            return (Criteria) this;
        }

        public Criteria andCouponlistBetween(String value1, String value2) {
            addCriterion("couponList between", value1, value2, "couponlist");
            return (Criteria) this;
        }

        public Criteria andCouponlistNotBetween(String value1, String value2) {
            addCriterion("couponList not between", value1, value2, "couponlist");
            return (Criteria) this;
        }

        public Criteria andBindtypeIsNull() {
            addCriterion("bindType is null");
            return (Criteria) this;
        }

        public Criteria andBindtypeIsNotNull() {
            addCriterion("bindType is not null");
            return (Criteria) this;
        }

        public Criteria andBindtypeEqualTo(String value) {
            addCriterion("bindType =", value, "bindtype");
            return (Criteria) this;
        }

        public Criteria andBindtypeNotEqualTo(String value) {
            addCriterion("bindType <>", value, "bindtype");
            return (Criteria) this;
        }

        public Criteria andBindtypeGreaterThan(String value) {
            addCriterion("bindType >", value, "bindtype");
            return (Criteria) this;
        }

        public Criteria andBindtypeGreaterThanOrEqualTo(String value) {
            addCriterion("bindType >=", value, "bindtype");
            return (Criteria) this;
        }

        public Criteria andBindtypeLessThan(String value) {
            addCriterion("bindType <", value, "bindtype");
            return (Criteria) this;
        }

        public Criteria andBindtypeLessThanOrEqualTo(String value) {
            addCriterion("bindType <=", value, "bindtype");
            return (Criteria) this;
        }

        public Criteria andBindtypeLike(String value) {
            addCriterion("bindType like", value, "bindtype");
            return (Criteria) this;
        }

        public Criteria andBindtypeNotLike(String value) {
            addCriterion("bindType not like", value, "bindtype");
            return (Criteria) this;
        }

        public Criteria andBindtypeIn(List<String> values) {
            addCriterion("bindType in", values, "bindtype");
            return (Criteria) this;
        }

        public Criteria andBindtypeNotIn(List<String> values) {
            addCriterion("bindType not in", values, "bindtype");
            return (Criteria) this;
        }

        public Criteria andBindtypeBetween(String value1, String value2) {
            addCriterion("bindType between", value1, value2, "bindtype");
            return (Criteria) this;
        }

        public Criteria andBindtypeNotBetween(String value1, String value2) {
            addCriterion("bindType not between", value1, value2, "bindtype");
            return (Criteria) this;
        }

        public Criteria andDiscountIsNull() {
            addCriterion("discount is null");
            return (Criteria) this;
        }

        public Criteria andDiscountIsNotNull() {
            addCriterion("discount is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountEqualTo(String value) {
            addCriterion("discount =", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotEqualTo(String value) {
            addCriterion("discount <>", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountGreaterThan(String value) {
            addCriterion("discount >", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountGreaterThanOrEqualTo(String value) {
            addCriterion("discount >=", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountLessThan(String value) {
            addCriterion("discount <", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountLessThanOrEqualTo(String value) {
            addCriterion("discount <=", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountLike(String value) {
            addCriterion("discount like", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotLike(String value) {
            addCriterion("discount not like", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountIn(List<String> values) {
            addCriterion("discount in", values, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotIn(List<String> values) {
            addCriterion("discount not in", values, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountBetween(String value1, String value2) {
            addCriterion("discount between", value1, value2, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotBetween(String value1, String value2) {
            addCriterion("discount not between", value1, value2, "discount");
            return (Criteria) this;
        }

        public Criteria andBegintimeIsNull() {
            addCriterion("beginTime is null");
            return (Criteria) this;
        }

        public Criteria andBegintimeIsNotNull() {
            addCriterion("beginTime is not null");
            return (Criteria) this;
        }

        public Criteria andBegintimeEqualTo(Date value) {
            addCriterion("beginTime =", value, "begintime");
            return (Criteria) this;
        }

        public Criteria andBegintimeNotEqualTo(Date value) {
            addCriterion("beginTime <>", value, "begintime");
            return (Criteria) this;
        }

        public Criteria andBegintimeGreaterThan(Date value) {
            addCriterion("beginTime >", value, "begintime");
            return (Criteria) this;
        }

        public Criteria andBegintimeGreaterThanOrEqualTo(Date value) {
            addCriterion("beginTime >=", value, "begintime");
            return (Criteria) this;
        }

        public Criteria andBegintimeLessThan(Date value) {
            addCriterion("beginTime <", value, "begintime");
            return (Criteria) this;
        }

        public Criteria andBegintimeLessThanOrEqualTo(Date value) {
            addCriterion("beginTime <=", value, "begintime");
            return (Criteria) this;
        }

        public Criteria andBegintimeIn(List<Date> values) {
            addCriterion("beginTime in", values, "begintime");
            return (Criteria) this;
        }

        public Criteria andBegintimeNotIn(List<Date> values) {
            addCriterion("beginTime not in", values, "begintime");
            return (Criteria) this;
        }

        public Criteria andBegintimeBetween(Date value1, Date value2) {
            addCriterion("beginTime between", value1, value2, "begintime");
            return (Criteria) this;
        }

        public Criteria andBegintimeNotBetween(Date value1, Date value2) {
            addCriterion("beginTime not between", value1, value2, "begintime");
            return (Criteria) this;
        }

        public Criteria andEndtimeIsNull() {
            addCriterion("endTime is null");
            return (Criteria) this;
        }

        public Criteria andEndtimeIsNotNull() {
            addCriterion("endTime is not null");
            return (Criteria) this;
        }

        public Criteria andEndtimeEqualTo(Date value) {
            addCriterion("endTime =", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeNotEqualTo(Date value) {
            addCriterion("endTime <>", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeGreaterThan(Date value) {
            addCriterion("endTime >", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("endTime >=", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeLessThan(Date value) {
            addCriterion("endTime <", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeLessThanOrEqualTo(Date value) {
            addCriterion("endTime <=", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeIn(List<Date> values) {
            addCriterion("endTime in", values, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeNotIn(List<Date> values) {
            addCriterion("endTime not in", values, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeBetween(Date value1, Date value2) {
            addCriterion("endTime between", value1, value2, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeNotBetween(Date value1, Date value2) {
            addCriterion("endTime not between", value1, value2, "endtime");
            return (Criteria) this;
        }

        public Criteria andCnameIsNull() {
            addCriterion("cname is null");
            return (Criteria) this;
        }

        public Criteria andCnameIsNotNull() {
            addCriterion("cname is not null");
            return (Criteria) this;
        }

        public Criteria andCnameEqualTo(String value) {
            addCriterion("cname =", value, "cname");
            return (Criteria) this;
        }

        public Criteria andCnameNotEqualTo(String value) {
            addCriterion("cname <>", value, "cname");
            return (Criteria) this;
        }

        public Criteria andCnameGreaterThan(String value) {
            addCriterion("cname >", value, "cname");
            return (Criteria) this;
        }

        public Criteria andCnameGreaterThanOrEqualTo(String value) {
            addCriterion("cname >=", value, "cname");
            return (Criteria) this;
        }

        public Criteria andCnameLessThan(String value) {
            addCriterion("cname <", value, "cname");
            return (Criteria) this;
        }

        public Criteria andCnameLessThanOrEqualTo(String value) {
            addCriterion("cname <=", value, "cname");
            return (Criteria) this;
        }

        public Criteria andCnameLike(String value) {
            addCriterion("cname like", value, "cname");
            return (Criteria) this;
        }

        public Criteria andCnameNotLike(String value) {
            addCriterion("cname not like", value, "cname");
            return (Criteria) this;
        }

        public Criteria andCnameIn(List<String> values) {
            addCriterion("cname in", values, "cname");
            return (Criteria) this;
        }

        public Criteria andCnameNotIn(List<String> values) {
            addCriterion("cname not in", values, "cname");
            return (Criteria) this;
        }

        public Criteria andCnameBetween(String value1, String value2) {
            addCriterion("cname between", value1, value2, "cname");
            return (Criteria) this;
        }

        public Criteria andCnameNotBetween(String value1, String value2) {
            addCriterion("cname not between", value1, value2, "cname");
            return (Criteria) this;
        }

        public Criteria andCidIsNull() {
            addCriterion("cid is null");
            return (Criteria) this;
        }

        public Criteria andCidIsNotNull() {
            addCriterion("cid is not null");
            return (Criteria) this;
        }

        public Criteria andCidEqualTo(Integer value) {
            addCriterion("cid =", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidNotEqualTo(Integer value) {
            addCriterion("cid <>", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidGreaterThan(Integer value) {
            addCriterion("cid >", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidGreaterThanOrEqualTo(Integer value) {
            addCriterion("cid >=", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidLessThan(Integer value) {
            addCriterion("cid <", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidLessThanOrEqualTo(Integer value) {
            addCriterion("cid <=", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidIn(List<Integer> values) {
            addCriterion("cid in", values, "cid");
            return (Criteria) this;
        }

        public Criteria andCidNotIn(List<Integer> values) {
            addCriterion("cid not in", values, "cid");
            return (Criteria) this;
        }

        public Criteria andCidBetween(Integer value1, Integer value2) {
            addCriterion("cid between", value1, value2, "cid");
            return (Criteria) this;
        }

        public Criteria andCidNotBetween(Integer value1, Integer value2) {
            addCriterion("cid not between", value1, value2, "cid");
            return (Criteria) this;
        }

        public Criteria andGoodstypeIsNull() {
            addCriterion("goodstype is null");
            return (Criteria) this;
        }

        public Criteria andGoodstypeIsNotNull() {
            addCriterion("goodstype is not null");
            return (Criteria) this;
        }

        public Criteria andGoodstypeEqualTo(Integer value) {
            addCriterion("goodstype =", value, "goodstype");
            return (Criteria) this;
        }

        public Criteria andGoodstypeNotEqualTo(Integer value) {
            addCriterion("goodstype <>", value, "goodstype");
            return (Criteria) this;
        }

        public Criteria andGoodstypeGreaterThan(Integer value) {
            addCriterion("goodstype >", value, "goodstype");
            return (Criteria) this;
        }

        public Criteria andGoodstypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("goodstype >=", value, "goodstype");
            return (Criteria) this;
        }

        public Criteria andGoodstypeLessThan(Integer value) {
            addCriterion("goodstype <", value, "goodstype");
            return (Criteria) this;
        }

        public Criteria andGoodstypeLessThanOrEqualTo(Integer value) {
            addCriterion("goodstype <=", value, "goodstype");
            return (Criteria) this;
        }

        public Criteria andGoodstypeIn(List<Integer> values) {
            addCriterion("goodstype in", values, "goodstype");
            return (Criteria) this;
        }

        public Criteria andGoodstypeNotIn(List<Integer> values) {
            addCriterion("goodstype not in", values, "goodstype");
            return (Criteria) this;
        }

        public Criteria andGoodstypeBetween(Integer value1, Integer value2) {
            addCriterion("goodstype between", value1, value2, "goodstype");
            return (Criteria) this;
        }

        public Criteria andGoodstypeNotBetween(Integer value1, Integer value2) {
            addCriterion("goodstype not between", value1, value2, "goodstype");
            return (Criteria) this;
        }

        public Criteria andGoodslxIsNull() {
            addCriterion("goodslx is null");
            return (Criteria) this;
        }

        public Criteria andGoodslxIsNotNull() {
            addCriterion("goodslx is not null");
            return (Criteria) this;
        }

        public Criteria andGoodslxEqualTo(Integer value) {
            addCriterion("goodslx =", value, "goodslx");
            return (Criteria) this;
        }

        public Criteria andGoodslxNotEqualTo(Integer value) {
            addCriterion("goodslx <>", value, "goodslx");
            return (Criteria) this;
        }

        public Criteria andGoodslxGreaterThan(Integer value) {
            addCriterion("goodslx >", value, "goodslx");
            return (Criteria) this;
        }

        public Criteria andGoodslxGreaterThanOrEqualTo(Integer value) {
            addCriterion("goodslx >=", value, "goodslx");
            return (Criteria) this;
        }

        public Criteria andGoodslxLessThan(Integer value) {
            addCriterion("goodslx <", value, "goodslx");
            return (Criteria) this;
        }

        public Criteria andGoodslxLessThanOrEqualTo(Integer value) {
            addCriterion("goodslx <=", value, "goodslx");
            return (Criteria) this;
        }

        public Criteria andGoodslxIn(List<Integer> values) {
            addCriterion("goodslx in", values, "goodslx");
            return (Criteria) this;
        }

        public Criteria andGoodslxNotIn(List<Integer> values) {
            addCriterion("goodslx not in", values, "goodslx");
            return (Criteria) this;
        }

        public Criteria andGoodslxBetween(Integer value1, Integer value2) {
            addCriterion("goodslx between", value1, value2, "goodslx");
            return (Criteria) this;
        }

        public Criteria andGoodslxNotBetween(Integer value1, Integer value2) {
            addCriterion("goodslx not between", value1, value2, "goodslx");
            return (Criteria) this;
        }

        public Criteria andCommissionIsNull() {
            addCriterion("commission is null");
            return (Criteria) this;
        }

        public Criteria andCommissionIsNotNull() {
            addCriterion("commission is not null");
            return (Criteria) this;
        }

        public Criteria andCommissionEqualTo(String value) {
            addCriterion("commission =", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionNotEqualTo(String value) {
            addCriterion("commission <>", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionGreaterThan(String value) {
            addCriterion("commission >", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionGreaterThanOrEqualTo(String value) {
            addCriterion("commission >=", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionLessThan(String value) {
            addCriterion("commission <", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionLessThanOrEqualTo(String value) {
            addCriterion("commission <=", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionLike(String value) {
            addCriterion("commission like", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionNotLike(String value) {
            addCriterion("commission not like", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionIn(List<String> values) {
            addCriterion("commission in", values, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionNotIn(List<String> values) {
            addCriterion("commission not in", values, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionBetween(String value1, String value2) {
            addCriterion("commission between", value1, value2, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionNotBetween(String value1, String value2) {
            addCriterion("commission not between", value1, value2, "commission");
            return (Criteria) this;
        }

        public Criteria andWlcommissionIsNull() {
            addCriterion("wlCommission is null");
            return (Criteria) this;
        }

        public Criteria andWlcommissionIsNotNull() {
            addCriterion("wlCommission is not null");
            return (Criteria) this;
        }

        public Criteria andWlcommissionEqualTo(String value) {
            addCriterion("wlCommission =", value, "wlcommission");
            return (Criteria) this;
        }

        public Criteria andWlcommissionNotEqualTo(String value) {
            addCriterion("wlCommission <>", value, "wlcommission");
            return (Criteria) this;
        }

        public Criteria andWlcommissionGreaterThan(String value) {
            addCriterion("wlCommission >", value, "wlcommission");
            return (Criteria) this;
        }

        public Criteria andWlcommissionGreaterThanOrEqualTo(String value) {
            addCriterion("wlCommission >=", value, "wlcommission");
            return (Criteria) this;
        }

        public Criteria andWlcommissionLessThan(String value) {
            addCriterion("wlCommission <", value, "wlcommission");
            return (Criteria) this;
        }

        public Criteria andWlcommissionLessThanOrEqualTo(String value) {
            addCriterion("wlCommission <=", value, "wlcommission");
            return (Criteria) this;
        }

        public Criteria andWlcommissionLike(String value) {
            addCriterion("wlCommission like", value, "wlcommission");
            return (Criteria) this;
        }

        public Criteria andWlcommissionNotLike(String value) {
            addCriterion("wlCommission not like", value, "wlcommission");
            return (Criteria) this;
        }

        public Criteria andWlcommissionIn(List<String> values) {
            addCriterion("wlCommission in", values, "wlcommission");
            return (Criteria) this;
        }

        public Criteria andWlcommissionNotIn(List<String> values) {
            addCriterion("wlCommission not in", values, "wlcommission");
            return (Criteria) this;
        }

        public Criteria andWlcommissionBetween(String value1, String value2) {
            addCriterion("wlCommission between", value1, value2, "wlcommission");
            return (Criteria) this;
        }

        public Criteria andWlcommissionNotBetween(String value1, String value2) {
            addCriterion("wlCommission not between", value1, value2, "wlcommission");
            return (Criteria) this;
        }

        public Criteria andSalesIsNull() {
            addCriterion("sales is null");
            return (Criteria) this;
        }

        public Criteria andSalesIsNotNull() {
            addCriterion("sales is not null");
            return (Criteria) this;
        }

        public Criteria andSalesEqualTo(Integer value) {
            addCriterion("sales =", value, "sales");
            return (Criteria) this;
        }

        public Criteria andSalesNotEqualTo(Integer value) {
            addCriterion("sales <>", value, "sales");
            return (Criteria) this;
        }

        public Criteria andSalesGreaterThan(Integer value) {
            addCriterion("sales >", value, "sales");
            return (Criteria) this;
        }

        public Criteria andSalesGreaterThanOrEqualTo(Integer value) {
            addCriterion("sales >=", value, "sales");
            return (Criteria) this;
        }

        public Criteria andSalesLessThan(Integer value) {
            addCriterion("sales <", value, "sales");
            return (Criteria) this;
        }

        public Criteria andSalesLessThanOrEqualTo(Integer value) {
            addCriterion("sales <=", value, "sales");
            return (Criteria) this;
        }

        public Criteria andSalesIn(List<Integer> values) {
            addCriterion("sales in", values, "sales");
            return (Criteria) this;
        }

        public Criteria andSalesNotIn(List<Integer> values) {
            addCriterion("sales not in", values, "sales");
            return (Criteria) this;
        }

        public Criteria andSalesBetween(Integer value1, Integer value2) {
            addCriterion("sales between", value1, value2, "sales");
            return (Criteria) this;
        }

        public Criteria andSalesNotBetween(Integer value1, Integer value2) {
            addCriterion("sales not between", value1, value2, "sales");
            return (Criteria) this;
        }

        public Criteria andSpreadCountIsNull() {
            addCriterion("spread_count is null");
            return (Criteria) this;
        }

        public Criteria andSpreadCountIsNotNull() {
            addCriterion("spread_count is not null");
            return (Criteria) this;
        }

        public Criteria andSpreadCountEqualTo(Integer value) {
            addCriterion("spread_count =", value, "spreadCount");
            return (Criteria) this;
        }

        public Criteria andSpreadCountNotEqualTo(Integer value) {
            addCriterion("spread_count <>", value, "spreadCount");
            return (Criteria) this;
        }

        public Criteria andSpreadCountGreaterThan(Integer value) {
            addCriterion("spread_count >", value, "spreadCount");
            return (Criteria) this;
        }

        public Criteria andSpreadCountGreaterThanOrEqualTo(Integer value) {
            addCriterion("spread_count >=", value, "spreadCount");
            return (Criteria) this;
        }

        public Criteria andSpreadCountLessThan(Integer value) {
            addCriterion("spread_count <", value, "spreadCount");
            return (Criteria) this;
        }

        public Criteria andSpreadCountLessThanOrEqualTo(Integer value) {
            addCriterion("spread_count <=", value, "spreadCount");
            return (Criteria) this;
        }

        public Criteria andSpreadCountIn(List<Integer> values) {
            addCriterion("spread_count in", values, "spreadCount");
            return (Criteria) this;
        }

        public Criteria andSpreadCountNotIn(List<Integer> values) {
            addCriterion("spread_count not in", values, "spreadCount");
            return (Criteria) this;
        }

        public Criteria andSpreadCountBetween(Integer value1, Integer value2) {
            addCriterion("spread_count between", value1, value2, "spreadCount");
            return (Criteria) this;
        }

        public Criteria andSpreadCountNotBetween(Integer value1, Integer value2) {
            addCriterion("spread_count not between", value1, value2, "spreadCount");
            return (Criteria) this;
        }

        public Criteria andSpreadStartAtIsNull() {
            addCriterion("spread_start_at is null");
            return (Criteria) this;
        }

        public Criteria andSpreadStartAtIsNotNull() {
            addCriterion("spread_start_at is not null");
            return (Criteria) this;
        }

        public Criteria andSpreadStartAtEqualTo(Date value) {
            addCriterion("spread_start_at =", value, "spreadStartAt");
            return (Criteria) this;
        }

        public Criteria andSpreadStartAtNotEqualTo(Date value) {
            addCriterion("spread_start_at <>", value, "spreadStartAt");
            return (Criteria) this;
        }

        public Criteria andSpreadStartAtGreaterThan(Date value) {
            addCriterion("spread_start_at >", value, "spreadStartAt");
            return (Criteria) this;
        }

        public Criteria andSpreadStartAtGreaterThanOrEqualTo(Date value) {
            addCriterion("spread_start_at >=", value, "spreadStartAt");
            return (Criteria) this;
        }

        public Criteria andSpreadStartAtLessThan(Date value) {
            addCriterion("spread_start_at <", value, "spreadStartAt");
            return (Criteria) this;
        }

        public Criteria andSpreadStartAtLessThanOrEqualTo(Date value) {
            addCriterion("spread_start_at <=", value, "spreadStartAt");
            return (Criteria) this;
        }

        public Criteria andSpreadStartAtIn(List<Date> values) {
            addCriterion("spread_start_at in", values, "spreadStartAt");
            return (Criteria) this;
        }

        public Criteria andSpreadStartAtNotIn(List<Date> values) {
            addCriterion("spread_start_at not in", values, "spreadStartAt");
            return (Criteria) this;
        }

        public Criteria andSpreadStartAtBetween(Date value1, Date value2) {
            addCriterion("spread_start_at between", value1, value2, "spreadStartAt");
            return (Criteria) this;
        }

        public Criteria andSpreadStartAtNotBetween(Date value1, Date value2) {
            addCriterion("spread_start_at not between", value1, value2, "spreadStartAt");
            return (Criteria) this;
        }

        public Criteria andSpreadEndAtIsNull() {
            addCriterion("spread_end_at is null");
            return (Criteria) this;
        }

        public Criteria andSpreadEndAtIsNotNull() {
            addCriterion("spread_end_at is not null");
            return (Criteria) this;
        }

        public Criteria andSpreadEndAtEqualTo(Date value) {
            addCriterion("spread_end_at =", value, "spreadEndAt");
            return (Criteria) this;
        }

        public Criteria andSpreadEndAtNotEqualTo(Date value) {
            addCriterion("spread_end_at <>", value, "spreadEndAt");
            return (Criteria) this;
        }

        public Criteria andSpreadEndAtGreaterThan(Date value) {
            addCriterion("spread_end_at >", value, "spreadEndAt");
            return (Criteria) this;
        }

        public Criteria andSpreadEndAtGreaterThanOrEqualTo(Date value) {
            addCriterion("spread_end_at >=", value, "spreadEndAt");
            return (Criteria) this;
        }

        public Criteria andSpreadEndAtLessThan(Date value) {
            addCriterion("spread_end_at <", value, "spreadEndAt");
            return (Criteria) this;
        }

        public Criteria andSpreadEndAtLessThanOrEqualTo(Date value) {
            addCriterion("spread_end_at <=", value, "spreadEndAt");
            return (Criteria) this;
        }

        public Criteria andSpreadEndAtIn(List<Date> values) {
            addCriterion("spread_end_at in", values, "spreadEndAt");
            return (Criteria) this;
        }

        public Criteria andSpreadEndAtNotIn(List<Date> values) {
            addCriterion("spread_end_at not in", values, "spreadEndAt");
            return (Criteria) this;
        }

        public Criteria andSpreadEndAtBetween(Date value1, Date value2) {
            addCriterion("spread_end_at between", value1, value2, "spreadEndAt");
            return (Criteria) this;
        }

        public Criteria andSpreadEndAtNotBetween(Date value1, Date value2) {
            addCriterion("spread_end_at not between", value1, value2, "spreadEndAt");
            return (Criteria) this;
        }

        public Criteria andSpreadTypeIsNull() {
            addCriterion("spread_type is null");
            return (Criteria) this;
        }

        public Criteria andSpreadTypeIsNotNull() {
            addCriterion("spread_type is not null");
            return (Criteria) this;
        }

        public Criteria andSpreadTypeEqualTo(String value) {
            addCriterion("spread_type =", value, "spreadType");
            return (Criteria) this;
        }

        public Criteria andSpreadTypeNotEqualTo(String value) {
            addCriterion("spread_type <>", value, "spreadType");
            return (Criteria) this;
        }

        public Criteria andSpreadTypeGreaterThan(String value) {
            addCriterion("spread_type >", value, "spreadType");
            return (Criteria) this;
        }

        public Criteria andSpreadTypeGreaterThanOrEqualTo(String value) {
            addCriterion("spread_type >=", value, "spreadType");
            return (Criteria) this;
        }

        public Criteria andSpreadTypeLessThan(String value) {
            addCriterion("spread_type <", value, "spreadType");
            return (Criteria) this;
        }

        public Criteria andSpreadTypeLessThanOrEqualTo(String value) {
            addCriterion("spread_type <=", value, "spreadType");
            return (Criteria) this;
        }

        public Criteria andSpreadTypeLike(String value) {
            addCriterion("spread_type like", value, "spreadType");
            return (Criteria) this;
        }

        public Criteria andSpreadTypeNotLike(String value) {
            addCriterion("spread_type not like", value, "spreadType");
            return (Criteria) this;
        }

        public Criteria andSpreadTypeIn(List<String> values) {
            addCriterion("spread_type in", values, "spreadType");
            return (Criteria) this;
        }

        public Criteria andSpreadTypeNotIn(List<String> values) {
            addCriterion("spread_type not in", values, "spreadType");
            return (Criteria) this;
        }

        public Criteria andSpreadTypeBetween(String value1, String value2) {
            addCriterion("spread_type between", value1, value2, "spreadType");
            return (Criteria) this;
        }

        public Criteria andSpreadTypeNotBetween(String value1, String value2) {
            addCriterion("spread_type not between", value1, value2, "spreadType");
            return (Criteria) this;
        }

        public Criteria andSpreadAmountIsNull() {
            addCriterion("spread_amount is null");
            return (Criteria) this;
        }

        public Criteria andSpreadAmountIsNotNull() {
            addCriterion("spread_amount is not null");
            return (Criteria) this;
        }

        public Criteria andSpreadAmountEqualTo(String value) {
            addCriterion("spread_amount =", value, "spreadAmount");
            return (Criteria) this;
        }

        public Criteria andSpreadAmountNotEqualTo(String value) {
            addCriterion("spread_amount <>", value, "spreadAmount");
            return (Criteria) this;
        }

        public Criteria andSpreadAmountGreaterThan(String value) {
            addCriterion("spread_amount >", value, "spreadAmount");
            return (Criteria) this;
        }

        public Criteria andSpreadAmountGreaterThanOrEqualTo(String value) {
            addCriterion("spread_amount >=", value, "spreadAmount");
            return (Criteria) this;
        }

        public Criteria andSpreadAmountLessThan(String value) {
            addCriterion("spread_amount <", value, "spreadAmount");
            return (Criteria) this;
        }

        public Criteria andSpreadAmountLessThanOrEqualTo(String value) {
            addCriterion("spread_amount <=", value, "spreadAmount");
            return (Criteria) this;
        }

        public Criteria andSpreadAmountLike(String value) {
            addCriterion("spread_amount like", value, "spreadAmount");
            return (Criteria) this;
        }

        public Criteria andSpreadAmountNotLike(String value) {
            addCriterion("spread_amount not like", value, "spreadAmount");
            return (Criteria) this;
        }

        public Criteria andSpreadAmountIn(List<String> values) {
            addCriterion("spread_amount in", values, "spreadAmount");
            return (Criteria) this;
        }

        public Criteria andSpreadAmountNotIn(List<String> values) {
            addCriterion("spread_amount not in", values, "spreadAmount");
            return (Criteria) this;
        }

        public Criteria andSpreadAmountBetween(String value1, String value2) {
            addCriterion("spread_amount between", value1, value2, "spreadAmount");
            return (Criteria) this;
        }

        public Criteria andSpreadAmountNotBetween(String value1, String value2) {
            addCriterion("spread_amount not between", value1, value2, "spreadAmount");
            return (Criteria) this;
        }

        public Criteria andDatastateIsNull() {
            addCriterion("datastate is null");
            return (Criteria) this;
        }

        public Criteria andDatastateIsNotNull() {
            addCriterion("datastate is not null");
            return (Criteria) this;
        }

        public Criteria andDatastateEqualTo(Boolean value) {
            addCriterion("datastate =", value, "datastate");
            return (Criteria) this;
        }

        public Criteria andDatastateNotEqualTo(Boolean value) {
            addCriterion("datastate <>", value, "datastate");
            return (Criteria) this;
        }

        public Criteria andDatastateGreaterThan(Boolean value) {
            addCriterion("datastate >", value, "datastate");
            return (Criteria) this;
        }

        public Criteria andDatastateGreaterThanOrEqualTo(Boolean value) {
            addCriterion("datastate >=", value, "datastate");
            return (Criteria) this;
        }

        public Criteria andDatastateLessThan(Boolean value) {
            addCriterion("datastate <", value, "datastate");
            return (Criteria) this;
        }

        public Criteria andDatastateLessThanOrEqualTo(Boolean value) {
            addCriterion("datastate <=", value, "datastate");
            return (Criteria) this;
        }

        public Criteria andDatastateIn(List<Boolean> values) {
            addCriterion("datastate in", values, "datastate");
            return (Criteria) this;
        }

        public Criteria andDatastateNotIn(List<Boolean> values) {
            addCriterion("datastate not in", values, "datastate");
            return (Criteria) this;
        }

        public Criteria andDatastateBetween(Boolean value1, Boolean value2) {
            addCriterion("datastate between", value1, value2, "datastate");
            return (Criteria) this;
        }

        public Criteria andDatastateNotBetween(Boolean value1, Boolean value2) {
            addCriterion("datastate not between", value1, value2, "datastate");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}